################################################## ############
## MOD Title: Torrent Stats In User Profile Mod
## MOD Author: RoadTrain < N/A > http://torrentpier.info/viewtopic.php?f=5&t=728
## MOD Version: 0.1
## :       
##   \      
## Installation Level: Easy
## Installation Time: 10 Minutes
## Files To Edit: includes/torrent_userprofile.php
## templates/default/usercp_viewprofile.tpl
## License: http://opensource.org/licenses/gpl-license.php GNU General Public License v2
################################################## ############
## For security purposes, please check: http://torrentpier.info/viewtopic.php?f=5&t=728
## for the latest version of this MOD. Although MODs are checked
## before being allowed in the MODs Database there is no guarantee
## that there are no security problems within the MOD. No support
## will be given for MODs not found within the MODs Database which
## can be found at http://torrentpier.info/
################################################## ############
## Author Notes:
## 
################################################## ############
## MOD History:
## 2008-05-12 - Version 0.1.0
## - initial release
##
################################################## ############
## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD
################################################## ############

# 
#-----[ OPEN ]---------------------------------
# 
includes/torrent_userprofile.php 

# 
#-----[ FIND ]---------------------------------
#
// Get users active torrents
$sql = 'SELECT f.forum_id, f.forum_name, t.topic_title, tor.size

# 
#-----[ REPLACE ALL QUERY WITH ]---------------------------------
#
// Get users active torrents
$sql = 'SELECT f.forum_id, f.forum_name, t.topic_title, tor.size,sn.seeders, sn.leechers, tr.*
FROM '. FORUMS_TABLE .' f, '. TOPICS_TABLE .' t, '. BT_TRACKER_TABLE .' tr, '. BT_TORRENTS_TABLE .' tor, '. BT_TRACKER_SNAP_TABLE ." sn
WHERE tr.user_id = $profile_user_id
AND tr.topic_id = tor.topic_id
AND sn.topic_id = tor.topic_id
AND tor.topic_id = t.topic_id
AND t.forum_id = f.forum_id
$not_auth_forums_sql
GROUP BY tr.topic_id
ORDER BY f.forum_name, t.topic_title";

# 
#-----[ FIND ]---------------------------------
#
$template->assign_block_vars('seed.seedrow', array(
'FORUM_NAME' => htmlCHR($seeding[$i]['forum_name']),
'TOPIC_TITLE' => wbr($seeding[$i]['topic_title']),
'U_VIEW_FORUM' => "viewforum.$phpEx?". POST_FORUM_URL .'='. $seeding[$i]['forum_id'],
'U_VIEW_TOPIC' => "viewtopic.$phpEx?". POST_TOPIC_URL .'='. $seeding[$i]['topic_id'] .'&amp;spmode=full#seeders',

# 
#-----[ AFTER, ADD ]---------------------------------
# 
'TOPIC_SEEDERS' => $seeding[$i]['seeders'],
'TOPIC_LEECHERS' => $seeding[$i]['leechers'],
'SPEED_UP' => ($seeding[$i]['speed_up']) ? humn_size($seeding[$i]['speed_up'], 0, 'KB') .'/s' : '-',# 
# 
#-----[ FIND ]---------------------------------
#
$template->assign_block_vars('leech.leechrow', array(
'FORUM_NAME' => htmlCHR($leeching[$i]['forum_name']),
'TOPIC_TITLE' => wbr($leeching[$i]['topic_title']),
'U_VIEW_FORUM' => "viewforum.$phpEx?". POST_FORUM_URL .'='. $leeching[$i]['forum_id'],
'U_VIEW_TOPIC' => "viewtopic.$phpEx?". POST_TOPIC_URL .'='. $leeching[$i]['topic_id'] .'&amp;spmode=full#leechers',
'COMPL_PERC' => $compl_perc, 

# 
#-----[ AFTER, ADD ]---------------------------------
# 
'TOPIC_SEEDERS' => $leeching[$i]['seeders'],
'TOPIC_LEECHERS' => $leeching[$i]['leechers'],
'SPEED_UP' => ($leeching[$i]['speed_up']) ? humn_size($leeching[$i]['speed_up'], 0, 'KB') .'/s' : '-',

#-----[ OPEN ]---------------------------------
# 
templates/default/usercp_viewprofile.tpl


# 
#-----[ FIND ]---------------------------------
#
colspan="4"


# 
#-----[ FOR EACH, REPLACE WITH ]---------------------------------
#
colspan="5"

# 
#-----[ FIND ]---------------------------------
#
<td class="row3 tCenter">{L_FORUM}</td>
<td colspan="2" class="row3 tCenter">{L_TOPICS}</td>

# 
#-----[ AFTER, ADD ]---------------------------------
#
<td colspan="3" class="row3 tCenter">{L_TORRENT}</td>

# 
#-----[ FIND ]---------------------------------
# around line 264
<td class="tCenter pad_4">{seed.seedrow.FORUM_NAME} ({seed.seedrow.U_VIEW_FORUM})</td>
<td colspan="2" class="pad_4">{seed.seedrow.TOPIC_TITLE} ({seed.seedrow.U_VIEW_TOPIC})</td>

# 
#-----[ AFTER, ADD ]---------------------------------
#
<td class="tCenter pad_4">
<div>


<span class="seedmed">{seed.seedrow.TOPIC_SEEDERS}</span><span class="med"> | </span><span class="leechmed">{seed.seedrow.TOPIC_LEECHERS}</span></p>
<p style="padding-top: 2px" class="seedsmall">{seed.seedrow.SPEED_UP}</p>
</div></td> 

# 
#-----[ FIND ]---------------------------------
# around line 286
<td class="row3 tCenter">{L_FORUM}</td>
<td class="row3 tCenter">{L_TOPICS}</td>
<td class="row3 tCenter">%</td>

# 
#-----[ AFTER, ADD ]---------------------------------
#
<td class="row3 tCenter">{L_TORRENT}</td>
# 
#-----[ FIND ]---------------------------------
# around line 292
<td class="tCenter pad_4">{leech.leechrow.FORUM_NAME} ({leech.leechrow.U_VIEW_FORUM})</td>
<td class="pad_4">{leech.leechrow.TOPIC_TITLE} ({leech.leechrow.U_VIEW_TOPIC})</td>
<td class="tCenter med">{leech.leechrow.COMPL_PERC}</td>
# 
#-----[ AFTER, ADD ]---------------------------------
#
<td class="tCenter pad_4">
<div>


<span class="seedmed">{leech.leechrow.TOPIC_SEEDERS}</span><span class="med"> | </span><span class="leechmed">{leech.leechrow.TOPIC_LEECHERS}</span></p>
<p style="padding-top: 2px" class="seedsmall">{leech.leechrow.SPEED_UP}</p>
</div></td> 

#
#-----[ SAVE/CLOSE ALL FILES ]---------------------------------
#
# EoM